<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-3-30. 16:23:32-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Storage and Storage Pool Capacity']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Storage Pool Forecast and Trends</staticValue></dataSource></textItem><textItem><dataSource><staticValue> For </staticValue></dataSource><style><CSS value="font-family:Arial;font-size:24px;color:#333333"/></style><conditionalRender refVariable="showLabel"><renderFor refVariableValue="1"/></conditionalRender></textItem><textItem><dataSource><reportExpression>ParamDisplayValue('sPool')</reportExpression></dataSource><style><CSS value="font-family:Arial;font-size:24px;color:#333333;background-color:#FFFFCC"/></style><conditionalRender refVariable="showLabel"><renderFor refVariableValue="1"/></conditionalRender></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Storage Pool Utilization Trends</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(for Last 7 Days)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart1" refQuery="Utilization - 7 Days">
																										<v2_combinationTypeTooltips/>
																										<v2_commonAxis>
																											<v2_ordinalAxis>
																												<v2_axisLabels>
																													<style>
																														<defaultStyles>
																															<defaultStyle refStyle="al"/>
																														</defaultStyles>
																														<CSS value="color:#454545"/></style>
																												</v2_axisLabels>
																											</v2_ordinalAxis>
																											<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource><style><dataFormat><dateFormat pattern="MM-dd"/></dataFormat></style></chartTextItem></chartContents><style><dataFormat><dateFormat showYears="false" showMonths="shortName" showDays="true"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																										<v2_topLeftAxis>
																											<v2_combinationChartTypes>
																												<v2_line lineDisplayType="lineAndMarkers">
																													<v2_linePalette markerSize="8pt">
																														<v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px" lineStyle="solid"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#3399CC"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#3399CC"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineStyle="dot" lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#CCCCFF"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#CCCCFF"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette>
																													<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Used (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_specialDataPoints><v2_firstPoint><v2_pointPaletteEntry markerShape="sphere32"><v2_fillEffect defaultColor="#198545"><v2_linearGradient><v2_gradientColor gradientColor="rgb(133,153,211)" colorPosition="0"/><v2_gradientColor gradientColor="rgb(88,118,174)" colorPosition="100"/></v2_linearGradient></v2_fillEffect></v2_pointPaletteEntry></v2_firstPoint><v2_lastPoint><v2_pointPaletteEntry markerShape="sphere32"><v2_fillEffect defaultColor="green"><v2_solidColor color="#009966"/></v2_fillEffect></v2_pointPaletteEntry></v2_lastPoint></v2_specialDataPoints></v2_line>
																											</v2_combinationChartTypes>
																											<v2_axis>
																												<v2_axisRange>
																													<v2_automaticRange/>
																												</v2_axisRange>
																												<v2_axisLabels>
																													<style>
																														<defaultStyles>
																															<defaultStyle refStyle="al"/>
																														</defaultStyles>
																														<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style>
																												</v2_axisLabels>
																												<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
																											</v2_axis>
																										</v2_topLeftAxis>
																										<style>
																											<defaultStyles>
																												<defaultStyle refStyle="ch"/>
																											</defaultStyles>
																											<CSS value="width:500px;height:225px"/></style>
																										<noDataHandler>
																											<contents>
																												<block>
																													<contents>
																														<textItem>
																															<dataSource>
																																<staticValue>No Data Available</staticValue>
																															</dataSource>
																															<style>
																																<CSS value="padding:10px 18px;"/>
																															</style>
																														</textItem>
																													</contents>
																												</block>
																											</contents>
																										</noDataHandler>
																										<v2_notes><v2_note refQuery="Utilization - 7 Days"><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>7 Days Trend</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems><style><CSS value="font-size:24pt;color:silver;font-weight:bold"/></style><v2_constrainedPosition><v2_verticalPosition><v2_middle offset="0px"/></v2_verticalPosition><v2_horizontalPosition><v2_right offset="0px"/></v2_horizontalPosition><v2_positionAnchor><v2_relativeChart/></v2_positionAnchor></v2_constrainedPosition></v2_note></v2_notes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Storage Pool Utilization Trends</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(for Last 30 Days)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart2" refQuery="Utilization - 30 Days">
							<v2_combinationTypeTooltips/>
							<v2_commonAxis>
								<v2_ordinalAxis>
									<v2_axisLabels>
										<style>
											<defaultStyles>
												<defaultStyle refStyle="al"/>
											</defaultStyles>
											<CSS value="color:#454545"/></style>
									</v2_axisLabels>
								</v2_ordinalAxis>
								<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource><style><dataFormat><dateFormat pattern="MM-dd"/></dataFormat></style></chartTextItem></chartContents><style><dataFormat><dateFormat showYears="false" showMonths="shortName" showDays="true"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
							<v2_topLeftAxis>
								<v2_combinationChartTypes>
									<v2_line lineDisplayType="lineAndMarkers">
										<v2_linePalette markerSize="8pt">
											<v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px" lineStyle="solid"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#3399CC"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#3399CC"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineStyle="dot" lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#CCCCFF"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#CCCCFF"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette>
										<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Used (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_specialDataPoints><v2_firstPoint><v2_pointPaletteEntry markerShape="sphere32"><v2_fillEffect defaultColor="#198545"><v2_linearGradient><v2_gradientColor gradientColor="rgb(133,153,211)" colorPosition="0"/><v2_gradientColor gradientColor="rgb(88,118,174)" colorPosition="100"/></v2_linearGradient></v2_fillEffect></v2_pointPaletteEntry></v2_firstPoint><v2_lastPoint><v2_pointPaletteEntry markerShape="sphere32"><v2_fillEffect defaultColor="green"><v2_solidColor color="#009966"/></v2_fillEffect></v2_pointPaletteEntry></v2_lastPoint></v2_specialDataPoints></v2_line>
								</v2_combinationChartTypes>
								<v2_axis>
									<v2_axisRange>
										<v2_automaticRange/>
									</v2_axisRange>
									<v2_axisLabels>
										<style>
											<defaultStyles>
												<defaultStyle refStyle="al"/>
											</defaultStyles>
											<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style>
									</v2_axisLabels>
									<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
								</v2_axis>
							</v2_topLeftAxis>
							<style>
								<defaultStyles>
									<defaultStyle refStyle="ch"/>
								</defaultStyles>
								<CSS value="width:500px;height:225px"/></style>
							<noDataHandler>
								<contents>
									<block>
										<contents>
											<textItem>
												<dataSource>
													<staticValue>No Data Available</staticValue>
												</dataSource>
												<style>
													<CSS value="padding:10px 18px;"/>
												</style>
											</textItem>
										</contents>
									</block>
								</contents>
							</noDataHandler>
							<v2_notes><v2_note refQuery="Utilization - 30 Days"><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>30 Days Trend</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems><style><CSS value="color:silver;font-size:24pt;font-weight:bold"/></style><v2_constrainedPosition><v2_verticalPosition><v2_middle offset="0px"/></v2_verticalPosition><v2_horizontalPosition><v2_right offset="0px"/></v2_horizontalPosition><v2_positionAnchor><v2_relativeChart/></v2_positionAnchor></v2_constrainedPosition></v2_note></v2_notes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;vertical-align:top"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Storage Pool Utilization Trends</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Monthly)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart3" refQuery="Utilization - 1 Year">
																										<v2_combinationTypeTooltips/>
																										<v2_commonAxis>
																											<v2_ordinalAxis>
																												<v2_axisLabels>
																													<style>
																														<defaultStyles>
																															<defaultStyle refStyle="al"/>
																														</defaultStyles>
																														<CSS value="color:#454545"/></style>
																												</v2_axisLabels>
																											</v2_ordinalAxis>
																											<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource><style><dataFormat><dateFormat pattern="yyyy-MM"/></dataFormat></style></chartTextItem></chartContents><style><dataFormat><dateFormat showYears="true" showMonths="shortName" showDays="true"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																										<v2_topLeftAxis>
																											<v2_combinationChartTypes>
																												<v2_line lineDisplayType="lineAndMarkers">
																													<v2_linePalette markerSize="8pt">
																														<v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px" lineStyle="solid"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#3399CC"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#3399CC"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineStyle="dot" lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#CCCCFF"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#CCCCFF"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette>
																													<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Used (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_specialDataPoints><v2_firstPoint><v2_pointPaletteEntry markerShape="sphere32"><v2_fillEffect defaultColor="#198545"><v2_linearGradient><v2_gradientColor gradientColor="rgb(133,153,211)" colorPosition="0"/><v2_gradientColor gradientColor="rgb(88,118,174)" colorPosition="100"/></v2_linearGradient></v2_fillEffect></v2_pointPaletteEntry></v2_firstPoint><v2_lastPoint><v2_pointPaletteEntry markerShape="sphere32"><v2_fillEffect defaultColor="green"><v2_solidColor color="#009966"/></v2_fillEffect></v2_pointPaletteEntry></v2_lastPoint></v2_specialDataPoints></v2_line>
																											</v2_combinationChartTypes>
																											<v2_axis>
																												<v2_axisRange>
																													<v2_automaticRange/>
																												</v2_axisRange>
																												<v2_axisLabels>
																													<style>
																														<defaultStyles>
																															<defaultStyle refStyle="al"/>
																														</defaultStyles>
																														<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style>
																												</v2_axisLabels>
																												<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
																											</v2_axis>
																										</v2_topLeftAxis>
																										<style>
																											<defaultStyles>
																												<defaultStyle refStyle="ch"/>
																											</defaultStyles>
																											<CSS value="width:500px;height:225px"/></style>
																										<noDataHandler>
																											<contents>
																												<block>
																													<contents>
																														<textItem>
																															<dataSource>
																																<staticValue>No Data Available</staticValue>
																															</dataSource>
																															<style>
																																<CSS value="padding:10px 18px;"/>
																															</style>
																														</textItem>
																													</contents>
																												</block>
																											</contents>
																										</noDataHandler>
																										<v2_notes><v2_note refQuery="Utilization - 1 Year"><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>1 Year Trend</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems><style><CSS value="font-size:24pt;color:silver;font-weight:bold"/></style><v2_constrainedPosition><v2_verticalPosition><v2_middle offset="0px"/></v2_verticalPosition><v2_horizontalPosition><v2_right offset="0px"/></v2_horizontalPosition><v2_positionAnchor><v2_relativeChart/></v2_positionAnchor></v2_constrainedPosition></v2_note></v2_notes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Storage Pool Utilization Trends</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Monthly)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart6" refQuery="Utilization - 3 Years">
																										<v2_combinationTypeTooltips/>
																										<v2_commonAxis>
																											<v2_ordinalAxis>
																												<v2_axisLabels>
																													<style>
																														<defaultStyles>
																															<defaultStyle refStyle="al"/>
																														</defaultStyles>
																														<CSS value="color:#454545"/></style>
																												</v2_axisLabels>
																											</v2_ordinalAxis>
																											<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource><style><dataFormat><dateFormat pattern="yyyy-MM"/></dataFormat></style></chartTextItem></chartContents><style><dataFormat><dateFormat showYears="true" showMonths="shortName" showDays="true"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																										<v2_topLeftAxis>
																											<v2_combinationChartTypes>
																												<v2_line lineDisplayType="lineAndMarkers">
																													<v2_linePalette markerSize="8pt">
																														<v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px" lineStyle="solid"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#3399CC"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#3399CC"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineStyle="dot" lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#CCCCFF"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#CCCCFF"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette>
																													<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Used (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_specialDataPoints><v2_firstPoint><v2_pointPaletteEntry markerShape="sphere32"><v2_fillEffect defaultColor="#198545"><v2_linearGradient><v2_gradientColor gradientColor="rgb(133,153,211)" colorPosition="0"/><v2_gradientColor gradientColor="rgb(88,118,174)" colorPosition="100"/></v2_linearGradient></v2_fillEffect></v2_pointPaletteEntry></v2_firstPoint><v2_lastPoint><v2_pointPaletteEntry markerShape="sphere32"><v2_fillEffect defaultColor="green"><v2_solidColor color="#009966"/></v2_fillEffect></v2_pointPaletteEntry></v2_lastPoint></v2_specialDataPoints></v2_line>
																											</v2_combinationChartTypes>
																											<v2_axis>
																												<v2_axisRange>
																													<v2_automaticRange/>
																												</v2_axisRange>
																												<v2_axisLabels>
																													<style>
																														<defaultStyles>
																															<defaultStyle refStyle="al"/>
																														</defaultStyles>
																														<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style>
																												</v2_axisLabels>
																												<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
																											</v2_axis>
																										</v2_topLeftAxis>
																										<style>
																											<defaultStyles>
																												<defaultStyle refStyle="ch"/>
																											</defaultStyles>
																											<CSS value="width:500px;height:225px"/></style>
																										<noDataHandler>
																											<contents>
																												<block>
																													<contents>
																														<textItem>
																															<dataSource>
																																<staticValue>No Data Available</staticValue>
																															</dataSource>
																															<style>
																																<CSS value="padding:10px 18px;"/>
																															</style>
																														</textItem>
																													</contents>
																												</block>
																											</contents>
																										</noDataHandler>
																										<v2_notes><v2_note refQuery="Utilization - 3 Years"><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>3 Year Trend</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems><style><CSS value="font-size:24pt;color:silver;font-weight:bold"/></style><v2_constrainedPosition><v2_verticalPosition><v2_middle offset="0px"/></v2_verticalPosition><v2_horizontalPosition><v2_right offset="0px"/></v2_horizontalPosition><v2_positionAnchor><v2_relativeChart/></v2_positionAnchor></v2_constrainedPosition></v2_note></v2_notes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;vertical-align:top"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px;padding-right:10px;padding-left:10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Storage Pool Utilization Trends</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Forecast)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart5" refQuery="Storage Forecast">
																										<v2_combinationTypeTooltips/>
																										<v2_commonAxis>
																											<v2_ordinalAxis>
																												<v2_axisLabels>
																													<style>
																														<defaultStyles>
																															<defaultStyle refStyle="al"/>
																														</defaultStyles>
																														<CSS value="color:#454545"/></style>
																												</v2_axisLabels>
																											</v2_ordinalAxis>
																											<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Full Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Full Date"/></dataSource><style><dataFormat><dateFormat pattern="yyyy-MM"/></dataFormat></style></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="(MM/dd/y)"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																										<v2_topLeftAxis>
																											<v2_combinationChartTypes>
																												<v2_line lineDisplayType="lineAndMarkers">
																													<v2_linePalette markerSize="8pt">
																														<v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineStyle="dot" lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#6699FF"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#CCCCFF"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px" lineStyle="dot"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#3399CC"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#3399CC"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette>
																													<v2_specialDataPoints><v2_firstPoint><v2_pointPaletteEntry markerShape="sphere32"><v2_fillEffect defaultColor="#198545"><v2_linearGradient><v2_gradientColor gradientColor="rgb(133,153,211)" colorPosition="0"/><v2_gradientColor gradientColor="rgb(88,118,174)" colorPosition="100"/></v2_linearGradient></v2_fillEffect></v2_pointPaletteEntry></v2_firstPoint><v2_lastPoint><v2_pointPaletteEntry markerShape="sphere32"><v2_fillEffect defaultColor="green"><v2_solidColor color="#009966"/></v2_fillEffect></v2_pointPaletteEntry></v2_lastPoint></v2_specialDataPoints><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Used (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Forecast Used (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line>
																											</v2_combinationChartTypes>
																											<v2_axis>
																												<v2_axisRange>
																													<v2_automaticRange/>
																												</v2_axisRange>
																												<v2_axisLabels>
																													<style>
																														<defaultStyles>
																															<defaultStyle refStyle="al"/>
																														</defaultStyles>
																														<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style>
																												</v2_axisLabels>
																												<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
																											</v2_axis>
																										</v2_topLeftAxis>
																										<style>
																											<defaultStyles>
																												<defaultStyle refStyle="ch"/>
																											</defaultStyles>
																											<CSS value="width:1025px;height:228px"/></style>
																										<noDataHandler>
																											<contents>
																												<block>
																													<contents>
																														<textItem>
																															<dataSource>
																																<staticValue>No Data Available</staticValue>
																															</dataSource>
																															<style>
																																<CSS value="padding:10px 18px;"/>
																															</style>
																														</textItem>
																													</contents>
																												</block>
																											</contents>
																										</noDataHandler>
																										<v2_notes><v2_note refQuery="Storage Forecast"><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>12 Month Forecast</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems><style><CSS value="font-size:24pt;color:silver;font-weight:bold"/></style><v2_constrainedPosition><v2_verticalPosition><v2_middle offset="0px"/></v2_verticalPosition><v2_horizontalPosition><v2_right offset="0px"/></v2_horizontalPosition><v2_positionAnchor><v2_relativeChart/></v2_positionAnchor></v2_constrainedPosition></v2_note></v2_notes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding:5px 10px 10px 10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Select Storage Pool:</staticValue></dataSource><style><CSS value="font-size:12pt;color:gray;font-weight:bold"/></style></textItem></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><selectValue parameter="sPool" required="false" selectValueUI="radioGroup" autoSubmit="true" refQuery="Storage Pool Prompt"><useItem refDataItem="Storage Pool"><displayItem refDataItem="Storage Pool"/></useItem><headerText><defaultText>Select Aggregrate</defaultText></headerText><style><CSS value="width:350px;height:650px"/></style></selectValue></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><promptButton type="next">
			<contents><textItem><dataSource><staticValue>Reset</staticValue></dataSource></textItem></contents>
			<style>
				<defaultStyles>
					<defaultStyle refStyle="bp"/>
				</defaultStyles>
			<CSS value="background-color:silver"/></style>
		</promptButton></contents><style><CSS value="padding-top:5px;padding-left:20px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;background-color:white;padding-top:10px;padding-right:10px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-left:15px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.811Z"/></XMLAttributes><reportName>2.6 Storage Pool Forecast and Trends</reportName><classStyles><classStyle name="freezeColumns" label="freezeColumns"/><classStyle name="freezeRows" label="freezeRows"/><classStyle name="freezeCorner" label="freezeCorner"/></classStyles><queries><query name="Storage Forecast">
			<source>
				
			<sqlQuery name="SQL3" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT DISTINCT
cap.StorageName as 'Storage Name',
cap.PoolName as 'Storage Pool',
cap.CapacityTB as 'Usable (TB)',
cap.UsedCapacityTB as 'Used (TB)',
cap.ProjectedCapacityTB as 'Forecast Usable (TB)',
cap.ProjectedUsedTB AS 'Forecast Used (TB)',
current.usedTB as 'Current Used (TB)',
cap.FullDate as 'Full Date'

FROM (

SELECT 	
	dwh_capacity.storage_dimension.datacenter as 'Data Center',
	dwh_capacity.storage_dimension.name as 'StorageName',
	dwh_capacity.storage_dimension.id as storageid,
	dwh_capacity.storage_pool_dimension.id as poolid,
	dwh_capacity.storage_dimension.manufacturer as 'Manufacturer',
	dwh_capacity.storage_dimension.model as 'Model',
	dwh_capacity.storage_pool_dimension.name as 'PoolName',
	dwh_capacity.tier_dimension.name as 'Tier Name',
	dwh_capacity.tier_dimension.cost as 'Cost',
	dwh_capacity.date_dimension.fullDate AS 'FullDate',
	
	                  
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawcapacityMB)/1024/1024, 2) AS 'Raw Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS 'CapacityTB',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS 'UsedCapacityTB',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) AS 'Provisioned (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeConsumedCapacityMB)/1024/1024, 2) AS 'Volume Consumed Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB)/1024/1024, 2) AS 'Internal Volume Allocated Capacity (TB)', 
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeConsumedCapacityMB)/1024/1024, 2) AS 'Internal Volume Consumed Capacity (TB)',
	
                   NULL AS 'Projected Raw Capacity (TB)',
	NULL AS 'ProjectedCapacityTB',
	NULL AS 'ProjectedUsedTB'
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
AND  	dwh_capacity.storage_pool_dimension.name &lt;&gt; 'N/A'
JOIN	dwh_capacity.tier_dimension
ON	dwh_capacity.tier_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.tiertk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.repMonthOrLatest = 1

WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN 
dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 365 DAY

GROUP BY
	dwh_capacity.storage_dimension.name, dwh_capacity.storage_pool_dimension.name, dwh_capacity.date_dimension.fullDate
UNION
SELECT 	
	dwh_capacity.storage_dimension.datacenter as 'Data Center',
	dwh_capacity.storage_dimension.name as 'StorageName',
	dwh_capacity.storage_dimension.id as storageid,
	dwh_capacity.storage_pool_dimension.id as poolid,
	dwh_capacity.storage_dimension.manufacturer as 'Manufacturer',
	dwh_capacity.storage_dimension.model as 'Model',
	dwh_capacity.storage_pool_dimension.name as 'PoolName',
	dwh_capacity.tier_dimension.name as 'Tier Name',
	dwh_capacity.tier_dimension.cost as 'Cost',
	dwh_capacity.date_dimension.fullDate AS 'FullDate',
	
	NULL AS 'Raw Capacity (TB)',
	NULL AS 'CapacityTB',
	NULL AS 'UsedCapacityTB',
	NULL AS 'Provisioned (TB)',
	NULL AS 'Volume Consumed Capacity (TB)',
	NULL AS 'Internal Volume Allocated Capacity (TB)',
	NULL AS 'Internal Volume Consumed Capacity (TB)',
	           

	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_future_fact.rawcapacityMB)/1024/1024, 2) AS 'Projected Raw Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_future_fact.capacityMB)/1024/1024, 2) AS 'ProjectedCapacityTB',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_future_fact.usedCapacityMB)/1024/1024, 2) AS 'ProjectedUsedTB'
FROM 	dwh_capacity.storage_and_storage_pool_capacity_future_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_future_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_future_fact.isVirtual = 0
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_future_fact.storagepooltk
AND  	dwh_capacity.storage_pool_dimension.name &lt;&gt; 'N/A'
JOIN	dwh_capacity.tier_dimension
ON	dwh_capacity.tier_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_future_fact.tiertk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_future_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.repMonthOrLatest = 1
GROUP BY
	dwh_capacity.storage_dimension.name, dwh_capacity.storage_pool_dimension.name, dwh_capacity.date_dimension.fullDate ) cap

JOIN

(


SELECT 	
	dwh_capacity.storage_dimension.id as storageid,
	dwh_capacity.storage_pool_dimension.id as poolid,
			
		ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS 'UsedTB'
		
		
	
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
AND  	dwh_capacity.storage_pool_dimension.name &lt;&gt; 'N/A'
JOIN	dwh_capacity.tier_dimension
ON	dwh_capacity.tier_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.tiertk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk



WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN 
dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY

GROUP BY dwh_capacity.storage_dimension.id, dwh_capacity.storage_pool_dimension.id
) current ON current.storageid=cap.storageid AND current.poolid=cap.poolid







</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Storage Pool"/><mdProjectedItem name="Usable (TB)"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Forecast Usable (TB)"/><mdProjectedItem name="Forecast Used (TB)"/><mdProjectedItem name="Current Used (TB)"/><mdProjectedItem name="Full Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL3].[Storage Name]</expression></dataItem><dataItem name="Storage Pool"><expression>[SQL3].[Storage Pool]</expression></dataItem><dataItem name="Usable (TB)" aggregate="total"><expression>[SQL3].[Usable (TB)]</expression></dataItem><dataItem name="Used (TB)" aggregate="total"><expression>[SQL3].[Used (TB)]</expression></dataItem><dataItem name="Forecast Usable (TB)" aggregate="total"><expression>[SQL3].[Forecast Usable (TB)]</expression></dataItem><dataItem name="Forecast Used (TB)" aggregate="total"><expression>[SQL3].[Forecast Used (TB)]</expression></dataItem><dataItem name="Current Used (TB)" aggregate="minimum"><expression>[SQL3].[Current Used (TB)]</expression></dataItem><dataItem name="Full Date"><expression>[SQL3].[Full Date]</expression></dataItem><dataItem name="Used (TB) in 12 Months" aggregate="total"><expression>if([Max Date]=[Full Date]) THEN ([Forecast Used (TB)]) ELSE (0)</expression></dataItem><dataItem name="Max Date"><expression>maximum([Full Date] for report)</expression></dataItem><dataItem name="Current for Report" aggregate="total"><expression>if([Max Date]=[Full Date]) THEN ([Current Used (TB)]) ELSE (0)</expression></dataItem><dataItem name="Effective Growth per Month" aggregate="total"><expression>([Used (TB) in 12 Months]-[Current for Report])/12</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Storage Pool]=?sPool?</filterExpression></detailFilter></detailFilters></query><query name="Utilization - 7 Days"><source><sqlQuery name="SQL1" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
dwh_capacity.storage_pool_dimension.name as 'Storage Pool',
ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024,2) as 'Used (TB)',
dwh_capacity.date_dimension.fulldate as 'Date'

FROM dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN dwh_capacity.storage_dimension
ON   dwh_capacity.storage_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagetk


JOIN dwh_capacity.storage_pool_dimension
ON   dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
AND  dwh_capacity.storage_pool_dimension.name &lt;&gt;'N/A'
JOIN dwh_capacity.date_dimension
ON   dwh_capacity.date_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.datetk
AND  dwh_capacity.date_dimension.repday=1

WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
FROM dwh_capacity.date_dimension JOIN  dwh_capacity.storage_and_storage_pool_capacity_fact 
ON  dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 7 DAY

GROUP BY dwh_capacity.storage_dimension.tk, dwh_capacity.storage_pool_dimension.tk, dwh_capacity.date_dimension.tk
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Pool"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Date"/></mdProjectedItems></sqlQuery></source><selection><dataItem name="Storage Pool"><expression>[SQL1].[Storage Pool]</expression></dataItem><dataItem name="Used (TB)" aggregate="total"><expression>[SQL1].[Used (TB)]</expression></dataItem><dataItem name="Date"><expression>[SQL1].[Date]</expression></dataItem></selection><detailFilters><detailFilter use="optional"><filterExpression>[Storage Pool]=?sPool?</filterExpression></detailFilter></detailFilters></query><query name="Utilization - 30 Days">
			<source>
				
			<sqlQuery name="SQL2" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
dwh_capacity.storage_pool_dimension.name as 'Storage Pool',
ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024,2) as 'Used (TB)',
dwh_capacity.date_dimension.fulldate as 'Date'

FROM dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN dwh_capacity.storage_dimension
ON   dwh_capacity.storage_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagetk


JOIN dwh_capacity.storage_pool_dimension
ON   dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
AND  dwh_capacity.storage_pool_dimension.name &lt;&gt;'N/A'
JOIN dwh_capacity.date_dimension
ON   dwh_capacity.date_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.datetk
AND  dwh_capacity.date_dimension.repday=1

WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
FROM dwh_capacity.date_dimension JOIN  dwh_capacity.storage_and_storage_pool_capacity_fact 
ON  dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 30 DAY

GROUP BY dwh_capacity.storage_dimension.tk, dwh_capacity.storage_pool_dimension.tk, dwh_capacity.date_dimension.tk
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Pool"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Pool"><expression>[SQL2].[Storage Pool]</expression></dataItem><dataItem name="Used (TB)" aggregate="total"><expression>[SQL2].[Used (TB)]</expression></dataItem><dataItem name="Date"><expression>[SQL2].[Date]</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Storage Pool]=?sPool?</filterExpression></detailFilter></detailFilters></query><query name="Utilization - 1 Year">
			<source>
				
			<sqlQuery name="SQL3" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
dwh_capacity.storage_pool_dimension.name as 'Storage Pool',
ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024,2) as 'Used (TB)',
dwh_capacity.date_dimension.fulldate as 'Date'

FROM dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN dwh_capacity.storage_dimension
ON   dwh_capacity.storage_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagetk


JOIN dwh_capacity.storage_pool_dimension
ON   dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
AND  dwh_capacity.storage_pool_dimension.name &lt;&gt;'N/A'
JOIN dwh_capacity.date_dimension
ON   dwh_capacity.date_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.datetk
AND  dwh_capacity.date_dimension.repmonthorlatest=1

WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
FROM dwh_capacity.date_dimension JOIN  dwh_capacity.storage_and_storage_pool_capacity_fact 
ON  dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 365 DAY

GROUP BY dwh_capacity.storage_dimension.tk, dwh_capacity.storage_pool_dimension.tk, dwh_capacity.date_dimension.tk
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Pool"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Pool"><expression>[SQL3].[Storage Pool]</expression></dataItem><dataItem name="Used (TB)" aggregate="total"><expression>[SQL3].[Used (TB)]</expression></dataItem><dataItem name="Date"><expression>[SQL3].[Date]</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Storage Pool]=?sPool?</filterExpression></detailFilter></detailFilters></query><query name="Utilization - 3 Years">
			<source>
				
			<sqlQuery name="SQL4" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
dwh_capacity.storage_pool_dimension.name as 'Storage Pool',
ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024,2) as 'Used (TB)',
dwh_capacity.date_dimension.fulldate as 'Date'

FROM dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN dwh_capacity.storage_dimension
ON   dwh_capacity.storage_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagetk


JOIN dwh_capacity.storage_pool_dimension
ON   dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
AND  dwh_capacity.storage_pool_dimension.name &lt;&gt;'N/A'
JOIN dwh_capacity.date_dimension
ON   dwh_capacity.date_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.datetk
AND  dwh_capacity.date_dimension.repmonthorlatest=1

WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
FROM dwh_capacity.date_dimension JOIN  dwh_capacity.storage_and_storage_pool_capacity_fact 
ON  dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 3 YEAR

GROUP BY dwh_capacity.storage_dimension.tk, dwh_capacity.storage_pool_dimension.tk, dwh_capacity.date_dimension.tk
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Pool"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Pool"><expression>[SQL4].[Storage Pool]</expression></dataItem><dataItem name="Used (TB)" aggregate="total"><expression>[SQL4].[Used (TB)]</expression></dataItem><dataItem name="Date"><expression>[SQL4].[Date]</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Storage Pool]=?sPool?</filterExpression></detailFilter></detailFilters></query><query name="Storage Pool Prompt">
			<source>
				
			<sqlQuery name="SQL5" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
dwh_capacity.storage_pool_dimension.name as 'Storage Pool'

FROM dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN dwh_capacity.storage_dimension
ON   dwh_capacity.storage_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagetk

JOIN dwh_capacity.storage_pool_dimension
ON   dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
AND  dwh_capacity.storage_pool_dimension.name &lt;&gt;'N/A'
JOIN dwh_capacity.date_dimension
ON   dwh_capacity.date_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.datetk
AND  dwh_capacity.date_dimension.repmonthorlatest=1

WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
FROM dwh_capacity.date_dimension JOIN  dwh_capacity.storage_and_storage_pool_capacity_fact 
ON  dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 3 YEAR

GROUP BY dwh_capacity.storage_dimension.tk, dwh_capacity.storage_pool_dimension.tk

ORDER BY dwh_capacity.storage_pool_dimension.name </sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Pool"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Pool"><expression>[SQL5].[Storage Pool]</expression></dataItem></selection>
		</query></queries><reportVariables><reportVariable type="boolean" name="showLabel">
			<reportExpression>ParamDisplayValue('sPool') is not null</reportExpression>
			<variableValues>
				<variableValue value="1"/>
			</variableValues>
		</reportVariable></reportVariables></report>